/*
 Navicat Premium Data Transfer

 Source Server         : 本地数据库
 Source Server Type    : MySQL
 Source Server Version : 50721
 Source Host           : localhost
 Source Database       : travel

 Target Server Type    : MySQL
 Target Server Version : 50721
 File Encoding         : utf-8

 Date: 09/03/2018 22:14:04 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `order_desc`
-- ----------------------------
DROP TABLE IF EXISTS `order_desc` ;
CREATE TABLE `order_desc` (
  `order_desc_id` varchar(255) NOT NULL COMMENT '订单详情id',
  `order_desc_type` varchar(255) DEFAULT NULL COMMENT '订单类型id',
  `order_on` varchar(255) DEFAULT NULL COMMENT '订单号',
  `order_desc_icon` varchar(255) DEFAULT NULL COMMENT '订单图标',
  `order_desc_count` varchar(255) DEFAULT NULL COMMENT '订单数量',
  `look_flag` varchar(255) DEFAULT '0' COMMENT '是否查阅0没有1有',
  `order_desc_money` decimal(10,0) DEFAULT NULL COMMENT '订单价格',
  `order_desc_create_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '订单创建时间',
  `order_desc_update_date` datetime DEFAULT NULL COMMENT '订单更新时间',
  `order_create_user_id` varchar(255) DEFAULT NULL COMMENT '创建订单的用户id',
  `order_desc_del` varchar(255) DEFAULT '0' COMMENT '订单状态0.未删除1.删除',
  `order_desc_pay_status` varchar(255) DEFAULT '0' COMMENT '订单支付状态0.未支付1已支付3.取消支付',
  `order_desc_note` varchar(255) DEFAULT NULL COMMENT '订单备注信息',
  `order_settlement_status` varchar(255) DEFAULT '0' COMMENT '订单结算状态 0一次性付清后发货1货到付款2分期付款',
  `order_settlement_time` datetime DEFAULT NULL COMMENT '订单结算时间',
  `order_finish` varchar(255) DEFAULT '0' COMMENT '订单是否完成0未完成1完成',
  PRIMARY KEY (`order_desc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单详情表';

-- ----------------------------
--  Records of `order_desc`
-- ----------------------------
BEGIN;
INSERT INTO `order_desc` VALUES ('131231231424124124', '0001', '1234567890', null, '2', '0', '3000', '2018-08-30 14:37:25', '2018-08-30 14:40:52', '2303256dad6e4405817c6ae23590e3c9', '0', '0', null, '0', null, '0');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
